<?php

use Illuminate\Database\Migrations\Migration;

class CreateOperatorOpeTable extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::create('Operator_ope', function($table)
	    {
	        $table->increments('ope_code');
	        $table->string('ope_name', 30);
	        $table->string('ope_login', 30)->unique();
	        $table->string('ope_rifci', 10)->unique();
	        $table->string('ope_email', 30)->unique();
	        $table->string('ope_phone', 11)->nullable();
	        $table->smallInteger('ope_status');
	        $table->smallInteger('ope_type');
	        $table->boolean('ope_active');
	        $table->binary('ope_image')->nullable();
	        $table->timestamps();
	    });
	}

	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		Schema::drop('Operator_ope');
	}

}